<!--#include file="Member_Inc.asp" -->
<!--#include Virtual="/Common/Cls_Page.asp" -->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>--会员中心</title>
<META HTTP-EQUIV="pragma" CONTENT="no-cache" />
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate" />
<META HTTP-EQUIV="expires" CONTENT="0" />
<link href="/skin/09/index.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body >

<!--top-->
<!--#include Virtual="/include/Head.asp" -->


<div class="top"></div>
<table width="940" border="0" align="center" cellpadding="0" cellspacing="0" class="sbj6">
  <tr>
    <td  width="248" height="52"><img src="img/qiye.gif" width="248" height="52"></td>
    <td width="742" background="img/qiye_bj.gif">&nbsp;</td>
  </tr>
</table>
  <table width="940" border="0" align="center" cellpadding="0" cellspacing="0" class="sbj6">
    <tr>
      <td width="769" height="678" valign="top"><table width="940" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="195" height="316" valign="top"><table width="195" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td  width="195" height="9"><img src="img/left_01.gif" width="195" height="9" /></td>
              </tr>
              <tr>
                <td height="218" valign="top" background="img/left_bj.gif"><table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                      <td  width="176" height="54"><img src="img/left_biao_01.gif" width="176" height="54" /></td>
                    </tr>
                    <tr>
                      <td height="82" valign="top" background="img/left_biao_bj.gif">
					  <% Call Left_Menu1() %>
				  </td>
                    </tr>
                    <tr>
                      <td  width="176" height="11"><img src="img/left_biao_di.gif" width="176" height="11" /></td>
                    </tr>
                  </table>
                    <table width="176" border="0" align="center" cellpadding="0" cellspacing="0" class="sbj8">
                      <tr>
                        <td  width="176" height="54"><img src="img/left_biao_04.gif" width="176" height="54" /></td>
                      </tr>
                      <tr>
                        <td height="66" valign="top" background="img/left_biao_bj.gif">

						<% Call Left_Menu2() %>


						</td>
                      </tr>
                      <tr>
                        <td  width="176" height="11"><img src="img/left_biao_di.gif" width="176" height="11" /></td>
                      </tr>
                  </table></td>
              </tr>
              <tr>
                <td  width="195" height="11"><img src="img/left_02.gif" width="195" height="11" /></td>
              </tr>
            </table></td>
            <td width="12">&nbsp;</td>
            <td valign="top">
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td width="112"><img src="img/xxgl.gif" width="112" height="32" /></td>
                        </tr>
                    </table></td>
                  </tr>

                </table>
                <table width="100%" border="1" cellspacing="0" cellpadding="0">
                  <tr>
                    <td>公司名称</td>
                    <td>地区</td>
                    <td>分类</td>
                    <td>发布时间</td>
                    <td>操作</td>
                  </tr>
				  <%
					Sql = " Update_Name ='"&Session("username")&"'"
		  
					'writebr sql
					Set Ors_Page = New Class_Page
			
					'================================
					'Table 查询的表或是视图
					Ors_Page.Table="uvw_YellowPage_Info"
			
					'Field SQL语句SELECT数据库的字段
					Ors_Page.Field="YPI_ID,YPI_Corp_Name,YP_Name,YPI_Area,Update_Date"
			
					'Pkey主键
					Ors_Page.Pkey="YPI_ID"
			
					'OrderBy 排序字段
					Ors_Page.OrderBy="Update_Date DESC"
			
					'Ors_Page.Order=1			'排序；0 顺序，1 倒序 
			
					Ors_Page.PageSize=10 '每页记录数
			
					'Condition 使用的条件，Tt_Title_Sql.....等等
					Ors_Page.Condition = Sql
			
			
					'PostString Tt_Title表单POST过来的值进行传递，该处适用POST和GET
					Ors_Page.PostString = ""
			
					RecCount = Ors_Page.RecCount() '记录总数
					rs_Array = Ors_Page.ResultSet() '返回ResultSet
					'================================
					If IsArray(rs_Array)=True Then
					For i=0 To Ubound(rs_Array,2)
						YPI_ID			= rs_Array(0,i)
						YPI_Corp_Name	= rs_Array(1,i)
						YP_Name			= rs_Array(2,i)
						YPI_Area		= rs_Array(3,i)
						Update_Date		= rs_Array(4,i)

				 %> 
                  <tr>
                    <td><%=YPI_Corp_Name%></td>
                    <td><%=YPI_Area%></td>
                    <td><%=YP_Name%></td>
                    <td><%=Update_Date%></td>
                    <td><a href="YP_Edit.asp?Info_ID=<%=YPI_ID%>">修改</a> <a href="YP_Del.asp?Info_ID=<%=YPI_ID%>">删除</a> </td>
                  </tr>
				<%
				Next
				If Ors_Page.PageCount>1 Then 
				%>
				<tr>
					<td colspan="4"><% Call Ors_Page.ShowPage() %> </td>
				</tr>
				<%
				End If
				Else 
				%>
				<tr>
					<td  colspan="4">没有找到你需要的数据</td>
				</tr>
				<% End If %>
			</table>
<p>&nbsp;</p></td>
                  </tr>
      </table>
            <br>              <br></td>
      </tr>
  </table>
  <!--/left-->
  <!--right-->
  <!--/right-->
</div>
<!--/d-->
<!--申请友情链接-->
<!--/e-->
</body>
</html>

 

<% Call Conn_Close() %>